Excel - Intro to Power Pivot
Organizing a lot of data? This is the power tool you need to manage it.
Bigger Brains
Summary
- Certificate of completion - Free
- Reed Courses Certificate of Completion - Free
Add to basket or enquire
Overview
Do you need to learn how to use Power Pivot in Excel? This course has you covered! In this course, you will be able to enable the Power Pivot add-in and navigate its interface, manage data relationships, create a Power Pivot report, create calculations in Power Pivot, create a Key Performance Indicator, and work with dates and time in Power Pivot.
Curriculum
Course media
Description
Learn how to transform Excel into your big data power tool
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
In this course, Microsoft certified trainer Barbara Evers will show you everything you need to know to install and start using Power Pivot in Excel.
We strongly recommend you take our “Mastering Excel” courses before you proceed with Power Pivot, unless you are comfortable with advanced Excel topics including basic Pivot Tables.
Topics covered include:
- Enabling the Power Pivot add-in and navigate its interface
- Managing data relationships
- Creating a Power Pivot Report
- Creating calculations in Power Pivot
- Creating a Key Performance Indicator
- Working with dates and time in Power Pivot
Quickly search for and find skills you want to master– then just point, click, and learn.
Over 60 minutes of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Who is this course for?
Advanced Excel users who are familiar with PivotTables and need to manage large amounts of data.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Certificate of completion
Digital certificate - Included
Reed Courses Certificate of Completion
Digital certificate - Included
Will be downloadable when all lectures have been completed.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.